joseph.ergo@proton.me
|
Portfolio
|
Resume PDF
|
Linked-In
|
+212 713-617-633
Available immediately for full/part-time remote roles
Table of contents
Introduction
Hello HCI team,
My name is Joseph, and it’s a pleasure to be a volunteer with the Happy City Index.
Before watching the video instruction, I had several questions and ideas. My two main ones are:
Gathering data from Reddit and applying sentiment analysis to discover how citizens feel about their city over time.
Gathering online resources on price changes for certain items, as I demonstrated in the report below.
I look forward to collaborating with everyone who shares the same passion.
Show the code
import plotly.express as px
import polars as pl
from pathlib import Path
import numpy as np
import plotly.io as pio
pio.renderers.default = 'jupyterlab+notebook'
pio.templates.default = "plotly_white"
Show the code
path_db = Path.cwd()/ 'outputs' / '04_db.parquet'
Show the code
df = pl.read_parquet(path_db)
Show the code
df_i = df['item' ].value_counts().sort('count' )
df_i_f = df_i.filter (pl.col('count' ).gt(pl.col('count' ).quantile(0.7 )))
Show the code
df_f = df.filter (pl.col('item' ).is_in(df_i_f['item' ].to_list())).sort(['year' ,'category' ,'item' ])
Price change from cost of living index - samle
Category: Buy Apartment Price
Item: Price per Square Feet to Buy Apartment Outside of Centre
Item: Price per Square Feet to Buy Apartment in City Centre
Category: Childcare
Item: International Primary School, Yearly for 1 Child
Item: Preschool (or Kindergarten), Full Day, Private, Monthly for 1 Child
Category: Clothing And Shoes
Item: 1 Pair of Jeans (Levis 501 Or Similar)
Item: 1 Pair of Men Leather Business Shoes
Item: 1 Pair of Nike Running Shoes (Mid-Range)
Item: 1 Summer Dress in a Chain Store (Zara, H&M, …)
Category: Markets
Item: Beef Round (1 lb) (or Equivalent Back Leg Red Meat)
Item: Bottle of Wine (Mid-Range)
Item: Cigarettes 20 Pack (Marlboro)
Item: Domestic Beer (0.5 liter bottle)
Item: Eggs (regular) (12)
Item: Imported Beer (12 oz small bottle)
Item: Loaf of Fresh White Bread (1 lb)
Item: Local Cheese (1 lb)
Item: Milk (regular), (1 gallon)
Item: Rice (white), (1 lb)
Item: Water (1.5 liter bottle)
Category: Rent Per Month
Item: Apartment (1 bedroom) Outside of Centre
Item: Apartment (1 bedroom) in City Centre
Item: Apartment (3 bedrooms) Outside of Centre
Item: Apartment (3 bedrooms) in City Centre
Category: Restaurants
Item: Cappuccino (regular)
Item: Imported Beer (12 oz small bottle)
Item: McMeal at McDonalds (or Equivalent Combo Meal)
Item: Meal for 2 People, Mid-range Restaurant, Three-course
Item: Meal, Inexpensive Restaurant
Category: Salaries And Financing
Item: Average Monthly Net Salary (After Tax)
Item: Mortgage Interest Rate in Percentages (%), Yearly, for 20 Years Fixed-Rate
Category: Sports And Leisure
Item: Cinema, International Release, 1 Seat
Item: Fitness Club, Monthly Fee for 1 Adult
Item: Tennis Court Rent (1 Hour on Weekend)
Category: Transportation
Item: Gasoline (1 gallon)
Item: Monthly Pass (Regular Price)
Item: One-way Ticket (Local Transport)
Item: Taxi 1 mile (Normal Tariff)
Item: Taxi 1hour Waiting (Normal Tariff)
Item: Taxi Start (Normal Tariff)
Item: Volkswagen Golf 1.4 90 KW Trendline (Or Equivalent New Car)
Category: Utilities (Monthly)
Item: 1 min. of Prepaid Mobile Tariff Local (No Discounts or Plans)
Item: Basic (Electricity, Heating, Cooling, Water, Garbage) for 915 sq ft Apartment
Item: Internet (60 Mbps or More, Unlimited Data, Cable/ADSL)